**"Descripteves statistics: TablesA8:A10**

* CHANGE THIS

cd /path/to/directory

**Table A8**

clear

use "data_src_Economics_w_covariates"

**using 2015 values because they reflect the state that the muni was at the end of 2014**

gen rural = 0 
replace rural = 1 if population < 15000 & urban <60


mean household_income_median if year==2015 & rural == 0 & Pretreated==0
mean household_income_median if year==2015 &  rural == 1 & Pretreated==0

mean unemployed if year==2015 & rural == 0 & Pretreated==0
mean unemployed if year==2015 & rural == 1 & Pretreated==0

mean dep_ratio if year==2015 & rural == 0 & Pretreated==0
mean dep_ratio if year==2015 & rural == 1 & Pretreated==0

mean populationchange if year==2015 & rural == 0 & Pretreated==0
mean populationchange if year==2015 &  rural == 1 & Pretreated==0

clear

****TABLE A9 independet variation, all municipalities***

use "data_src_parallel2000-15,reduced.dta"

sum population if year==2015, d
sum populationchange if year==2015, d
sum urban if year==2015, d

***treatment intensity comes from municipality info**
clear
use "data_src_Muni_info.dta"

sum capacity if Treated2015==1, d
sum refugees_per_capita if Treated2015==1, d

****TABLE A10 independet variation, previously receving municipalities excluded ***

use "data_src_parallel2000-15,reduced.dta"

sum population if year==2015 & Pretreated==0, d
sum populationchange if year==2015 & Pretreated==0, d
sum urban if year==2015 & Pretreated==0, d

***treatment intensity comes from municipality info**
clear
use "data_src_Muni_info.dta"

sum capacity if Treated2015==1 & Pretreated==0, d
sum refugees_per_capita if Treated2015==1 & Pretreated==0, d
